UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bo0Mz5teYZHp5OB0FSjCiv3rEK3zb5ZduiP4gsxXFC4='
WHERE
key_id = '2047f8262f3ef396044949502902d04ed4bb0e34a7ea70292a422d3f2d9146f8'
AND (
token = 'bo0Mz5teYZHp5OB0FSjCiv3rEK3zb5ZduiP4gsxXFC4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)