UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1gu/OW2X4tQRJzdcwLSLDbtWI9WUvY8sJjhibKBTojI='
WHERE
key_id = '8fc7e4c6a39bac40d1bb86da13a28cf30b694f661a2b255f3e3aa0b3658bb2f8'
AND (
token = '1gu/OW2X4tQRJzdcwLSLDbtWI9WUvY8sJjhibKBTojI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)