UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1bZpiGzOWp5frb0J10uvt+gPBIeFf44dovZrPrXWx1U='
WHERE
key_id = '8269841c65b65fc651d904021605ecbb1e312fac82562d5d90955a0db62f1480'
AND (
token = '1bZpiGzOWp5frb0J10uvt+gPBIeFf44dovZrPrXWx1U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)