UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4ZQYPTKjOSS+yarMBQsyaxsreVabGouZbjyz9d3mAjU='
WHERE
key_id = '9bd8d46fc8f9d3027ab6ce64c4923d54a34bc61962708725af514afb8a1fa40a'
AND (
token = '4ZQYPTKjOSS+yarMBQsyaxsreVabGouZbjyz9d3mAjU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)