UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zfnCKHplXnz3alz6yqmjD1m1ZmQWoEn9dQ6EXqNfI9w='
WHERE
key_id = 'c203743a77ae0b399fd5801777b83fe4a9505db88dfe3a50398678bb7a9f9e23'
AND (
token = 'zfnCKHplXnz3alz6yqmjD1m1ZmQWoEn9dQ6EXqNfI9w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)