UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZYtyxn5a28/TloXCUdwdKrT0Ye3fYKFtVx7RJupFjdA='
WHERE
key_id = '8dc2f2e6d6edae0ce3e405e73a5c02450ef32f6085567cdac35cc6ab85f27fd4'
AND (
token = 'ZYtyxn5a28/TloXCUdwdKrT0Ye3fYKFtVx7RJupFjdA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)