UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8bp2kdbJTUoJA4UdbZ6vaRZ/GK19KqQA5cElrj3Grgk=' 
WHERE 
  key_id = 'b30225d78e4dddba90d35274605850a69cafd5669a0e962fff2399b7c09f6b24' 
  AND (
    token = '8bp2kdbJTUoJA4UdbZ6vaRZ/GK19KqQA5cElrj3Grgk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045