UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ogZF7+Md7B0qzZIxxGi/0yZTZrxzCKA8ErbizaKxkI='
WHERE
key_id = 'a8e36d27f46f2a34ac6edf5ed9a63aeb1c5f5eee8e01028316a4ae5c323ea596'
AND (
token = '8ogZF7+Md7B0qzZIxxGi/0yZTZrxzCKA8ErbizaKxkI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)