UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '42+xt8KwJKnR3wheZbLbOS/TgcTy8N0mdja4jVZffpY='
WHERE
key_id = 'e719f8b899729a5d57877dda4934f287bda548802393fd96149a91dcadaa1d7a'
AND (
token = '42+xt8KwJKnR3wheZbLbOS/TgcTy8N0mdja4jVZffpY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)