UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5NXYbNC7vgzoTtlA8Agrj2sPQJu7Q3uFbtKz1Tazbso='
WHERE
key_id = '97ca9d779b9a3a9c711cd9bb1f42902f7ce7a8147c22bd28519445401e3c7cb4'
AND (
token = '5NXYbNC7vgzoTtlA8Agrj2sPQJu7Q3uFbtKz1Tazbso='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)