UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q2i8iDMPTiZTVZnWsM0q8GdkXBQrwmn7Sw2gOiT054w='
WHERE
key_id = 'e28d634fd3dc205e4cc748a437f8144ac5c227a4aa8b1f31573b6d9461900634'
AND (
token = 'Q2i8iDMPTiZTVZnWsM0q8GdkXBQrwmn7Sw2gOiT054w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)