UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EsaT9Ub70dFHsU7PEo7JjM33bW3Sbi+J06zwWvYh6vw='
WHERE
key_id = '042e58863f6703a5665ff1d9fb4d82488c279119dc2f2780db108224f458a125'
AND (
token = 'EsaT9Ub70dFHsU7PEo7JjM33bW3Sbi+J06zwWvYh6vw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)