UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5n+WiADrAbzT3Tw5Yi+FJy/ytyAthYGeb6nD3TrLCO8='
WHERE
key_id = 'de87051918cab29d77ca623d0d4bc5ced1c74d6d858285a139fc086825cdbbce'
AND (
token = '5n+WiADrAbzT3Tw5Yi+FJy/ytyAthYGeb6nD3TrLCO8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)