UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'prsHlGdL0//68r36/3r2iU0Kjav1jiUZ3CWo2GU1MCk='
WHERE
key_id = 'b1ca312367b206c139a04bd933b912448418b5043271715767af9905184b5686'
AND (
token = 'prsHlGdL0//68r36/3r2iU0Kjav1jiUZ3CWo2GU1MCk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)