UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zaDp8hN4SqEQYeCrPfvK4P7hTSTCw7U41OgiuUd6uxI='
WHERE
key_id = '767801e84e4dbf4f0ac8045870e205ae08c52ab39ff0fa6b2ccdb0a6d0633c8f'
AND (
token = 'zaDp8hN4SqEQYeCrPfvK4P7hTSTCw7U41OgiuUd6uxI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)