UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OacexOlaOwHZa7nWtM0bppMhMwpyWnqfq3Nwsim6uqc='
WHERE
key_id = 'f78ef999640d025eba071144e493be4c277af72d8759d44739884a259cd6816e'
AND (
token = 'OacexOlaOwHZa7nWtM0bppMhMwpyWnqfq3Nwsim6uqc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)