UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fdnyJFRK7l2PHv2S5Je59vcOXgcE8tSAh+ZZtT87C2M='
WHERE
key_id = '520e3a246aeafa57bda1150270772fd7b237db124e3db2171e49542a861f82d4'
AND (
token = 'fdnyJFRK7l2PHv2S5Je59vcOXgcE8tSAh+ZZtT87C2M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)