UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xg5IcOcnul2+7PDQnySJcSkabJWB1VLwPmIWU9VbjUo='
WHERE
key_id = '1eb8933aa01f540163aa9368d7a56405ce12adc9ca56a77bcf918d303ef87890'
AND (
token = 'Xg5IcOcnul2+7PDQnySJcSkabJWB1VLwPmIWU9VbjUo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)