UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1DrHH0VsXqm1nx9VsOiabUWoCj/7/yjGfQnjXkVeHBU='
WHERE
key_id = '3af1f0ef78539dadd603e432b7f37ace49823911dfc039436465fe6163d5219a'
AND (
token = '1DrHH0VsXqm1nx9VsOiabUWoCj/7/yjGfQnjXkVeHBU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)