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