UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6GQCAejQRGfWeAQmJ8PBRdzUIQqkTlfOCjRdKle0oRU='
WHERE
key_id = '7f8edbfecb8570504cdc976d07cdeca340d9d094f44522da68d88aff429387b7'
AND (
token = '6GQCAejQRGfWeAQmJ8PBRdzUIQqkTlfOCjRdKle0oRU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)