UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LOFkSMjkesJiaDw37Vy1YphEaym/VezwqeXbE4MEKPU='
WHERE
key_id = '48b78d0a8ae7d3ea04f076e0b0d743038e39281d6c763e6b2c9bfdcb822a8022'
AND (
token = 'LOFkSMjkesJiaDw37Vy1YphEaym/VezwqeXbE4MEKPU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)