UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KNxgN+W0JBuZ/V8ttX5QpRpkKOV/8EYPglpd26ZuOZg='
WHERE
key_id = '565eef47ab6ec06468ed44902da90f22fafe420ccf27bc3f6880207fae1ae9fb'
AND (
token = 'KNxgN+W0JBuZ/V8ttX5QpRpkKOV/8EYPglpd26ZuOZg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)