UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PiThHwox5j572fqZi8Fp/649kQaJFZfdBd7GzI30sB8='
WHERE
key_id = 'fb94c867f0a90d900e90557ed03435761916e69d2e295cfee6d6e3b785254fa5'
AND (
token = 'PiThHwox5j572fqZi8Fp/649kQaJFZfdBd7GzI30sB8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)