UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1vDc2r5647ssU+CKEmTOPn4Ozui9Ai6mmlAoC0KUmJ8='
WHERE
key_id = '4efb805e2cbbe70c6452ee1dd00708955c99a8564586b2ac1ff3bd08be7731f5'
AND (
token = '1vDc2r5647ssU+CKEmTOPn4Ozui9Ai6mmlAoC0KUmJ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)