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