UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sXkFBtVkdTCA0deJT4P4fqJr7n5juFyRYr8Qj/x9anc='
WHERE
key_id = '27526c411cb35cc4d048d91857553895dd5f6bc93dbc982e15dedd086d4ff4f9'
AND (
token = 'sXkFBtVkdTCA0deJT4P4fqJr7n5juFyRYr8Qj/x9anc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)