UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p45mzZeGOtUqcNm3TP71C1e6WhNljAHS2Dlb869UrHg='
WHERE
key_id = 'f6047226f9a7503d795495d79d9b7eb78f05cc9b3172cd26ce3ab7a04b9540fb'
AND (
token = 'p45mzZeGOtUqcNm3TP71C1e6WhNljAHS2Dlb869UrHg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)