UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R9EuRSUi3+8HEC0V43Ltbn3Aty4J4hlqsgcx1jKFrwk='
WHERE
key_id = 'b60eebc1299a837c0c83b8e7bd9f6ada97c37aeff8262af4420aab0725849bc1'
AND (
token = 'R9EuRSUi3+8HEC0V43Ltbn3Aty4J4hlqsgcx1jKFrwk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)