UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZsrU8QHiTU7nZWfUA73r9nYZ5bNTfT1Ygu9NBMsTUs8='
WHERE
key_id = '2dbb1978cfa2f71e66f9c21d767e89da16948b5f44e6f37ab97df32e5959981e'
AND (
token = 'ZsrU8QHiTU7nZWfUA73r9nYZ5bNTfT1Ygu9NBMsTUs8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)