UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZWAll2eF+LmPEwNOn83Ppbz0fBjpmhyNlzJx8T7mKTI='
WHERE
key_id = 'e3d9f033f67408e9f6e0e215f56dd40d214f06b04447cf9b4b7a55219b8f9049'
AND (
token = 'ZWAll2eF+LmPEwNOn83Ppbz0fBjpmhyNlzJx8T7mKTI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)