UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r7x3CrEA/b9XPLTSWl0pjkK8onazuzJCJJctEfJTleI='
WHERE
key_id = 'bc646153d1d9baa983f1d66e93c7388845958bc623a29c27750301766fc421fa'
AND (
token = 'r7x3CrEA/b9XPLTSWl0pjkK8onazuzJCJJctEfJTleI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)